COVID-19 in Italy. Visuals

(alternatively, see results and code together here)

 

Data source: this GitHubi page

Authors and sources mentioned: Editore/Autore del dataset: Dipartimento della Protezione Civile. Categoria ISO 19115: Salute. Dati forniti dal Ministero della Salute.

Regional data files (Dati per Regione):
  • Struttura file giornaliero: dpc-covid19-ita-regioni-yyyymmdd.csv (dpc-covid19-ita-regioni-20200224.csv)
  • File complessivo: dpc-covid19-ita-regioni.csv
  • File ultimi dati (latest): dpc-covid19-ita-regioni-latest.csv

 

Out[4]:

Currently data as of date: 2021-03-09T17:00:00

 

What's in the original dataframe?

Out[5]:

All column names: ['data', 'stato', 'codice_regione', 'denominazione_regione', 'lat', 'long', 'ricoverati_con_sintomi', 'terapia_intensiva', 'totale_ospedalizzati', 'isolamento_domiciliare', 'totale_positivi', 'variazione_totale_positivi', 'nuovi_positivi', 'dimessi_guariti', 'deceduti', 'casi_da_sospetto_diagnostico', 'casi_da_screening', 'totale_casi', 'tamponi', 'casi_testati', 'note', 'ingressi_terapia_intensiva', 'note_test', 'note_casi', 'totale_positivi_test_molecolare', 'totale_positivi_test_antigenico_rapido', 'tamponi_test_molecolare', 'tamponi_test_antigenico_rapido', 'codice_nuts_1', 'codice_nuts_2']

Out[6]:
data stato codice_regione denominazione_regione lat long ricoverati_con_sintomi terapia_intensiva totale_ospedalizzati isolamento_domiciliare ... note ingressi_terapia_intensiva note_test note_casi totale_positivi_test_molecolare totale_positivi_test_antigenico_rapido tamponi_test_molecolare tamponi_test_antigenico_rapido codice_nuts_1 codice_nuts_2
7975 2021-03-09T17:00:00 ITA 19 Sicilia 38.115697 13.362357 665 112 777 13425 ... NaN 9.0 NaN NaN 157498.0 0.0 1816018.0 838005.0 ITG ITG1
7976 2021-03-09T17:00:00 ITA 9 Toscana 43.769231 11.255889 1215 209 1424 20733 ... NaN 17.0 NaN NaN 165500.0 952.0 2590352.0 332512.0 ITI ITI1
7977 2021-03-09T17:00:00 ITA 10 Umbria 43.106758 12.388247 431 79 510 6360 ... Si fa presente che 12 dei ricoveri NON UTI, no... 3.0 NaN NaN 46713.0 0.0 722840.0 140485.0 ITI ITI2
7978 2021-03-09T17:00:00 ITA 2 Valle d'Aosta 45.737503 7.320149 9 2 11 184 ... NaN 0.0 NaN NaN 8159.0 0.0 76120.0 4818.0 ITC ITC2
7979 2021-03-09T17:00:00 ITA 5 Veneto 45.434905 12.338452 1013 141 1154 29056 ... Nei valori riportati per le terapie intensive ... 29.0 NaN NaN 339378.0 5497.0 4157977.0 1178965.0 ITH ITH3

5 rows × 30 columns

 

Variable names to English and their explanation

  • HospWithSymptoms : Currently hospitalized patients with symptoms
  • IC : Intensive care
  • HospTotal: Total number of currently hospitalized patients
  • AtHome : Currently at home confinement
  • CurrentlyPositive : Total amount of current positive cases (Hospitalised patients + Home confinement)
  • NewPositives : New amount of positive cases (Actual total amount of current positive cases - total amount of current positive cases of the previous day)
  • TotalCases : Total amount of positive cases
  • NoOfTests : Tests performed
Out[7]:
Date Region Lat Long HospWithSymptoms IC HospTotal AtHome CurrentlyPositive VariationOfPositives ... ingr_ter_intens note_test note_casi totale_positivi_test_molecolare totale_positivi_test_antigenico_rapido tamponi_test_molecolare tamponi_test_antigenico_rapido codice_nuts_1 codice_nuts_2 Pop
Date
2021-03-05 2021-03-05 Veneto 45.434905 12.338452 878 129 1007 26433 27440 839 ... 13.0 NaN NaN 334533.0 5209.0 4109934.0 1103801.0 ITH ITH3 4879133
2021-03-06 2021-03-06 Veneto 45.434905 12.338452 902 132 1034 27258 28292 852 ... 9.0 NaN NaN 336072.0 5209.0 4125564.0 1130015.0 ITH ITH3 4879133
2021-03-07 2021-03-07 Veneto 45.434905 12.338452 917 132 1049 28019 29068 776 ... 10.0 NaN NaN 337301.0 5209.0 4136572.0 1146831.0 ITH ITH3 4879133
2021-03-08 2021-03-08 Veneto 45.434905 12.338452 950 137 1087 28427 29514 446 ... 8.0 NaN NaN 337770.0 5497.0 4142229.0 1151434.0 ITH ITH3 4879133
2021-03-09 2021-03-09 Veneto 45.434905 12.338452 1013 141 1154 29056 30210 696 ... 29.0 NaN NaN 339378.0 5497.0 4157977.0 1178965.0 ITH ITH3 4879133

5 rows × 29 columns

 

daily numbers & moving averages (MA)

(double click and click on legend to select one or multiple regions in the graph)

 

All regions together

Molecular test positive rate

Antigene test positive rate